Microsoft Excel is full of calculations functions.
We've spoken about a few of them as you've gone through this course if functions V look ups.
H look at the index and match functions.
sumif, all sorts of functions.
Now it's great.
It sells a very powerful a very robust tool.
Now no matter how careful you are as you build calculations at some point you're going to run into errors
.
So what don't want to talk about here is how we can audit some of the formulas that you'll be creating
within your career within Excel.
The first feature I want to take a look at here deals with Tracy.
The precedence of formula or looking to see which cells a formula uses.
This is a great excellent tool to use if you ever inherit a workbook from somebody else that has a bunch
of calculations in there.
But now you need to know how those calculations were created and what's going to affect the outcome
of those calculations.
What if I change this cell.
Does that change the calculation.
How about this one over here.
Does that change it.
Let's take a look at how we can trace the cells that a formula relies on.
Take a look.
So open in front of you.
I've got the example file open.
I'm currently on the formula auditing worksheet.
This is if you took part in the first section of this course this should look very familiar to you.
It says the IF function workdays create a copy of it.
Now we can use it to build the audit with.
Now let's take for example just one of these simple little totals here.
I'm going to click in the cell.
EF 5 This is H James is total for the month of December 2015.
Now we know what sells is for meal relies on where's it getting it some is it coming up with 36000.
Well how about this cell over here.
H 5 was the gold met for H James well now it's perhaps not as clear which sells that formula is using
.
So I want to be able to trace what cells are really feeding information into this formula.
Take a look.
So I clicked inside a cell.
H5.
I'm going to go to my formulas tab top of the screen and towards the far right you have a section called
formula Oddity.
And in there I've got to trace buttons.
We're going to talk about the first one here.
Trace precedents.
So the idea is I've selected the cell has got a formula in it.
Now I want to know what cells contribute towards that formula.
I'll give that by Nikolic.
And now it's drawing these arrows from the cells that that formula relies on I can see that the total
is included in there and the monthly goal the strain on the one and then click on this guy down here
this hundred seventy six thousand two hundred eleven and I to know what cells contribute towards that
total.
If I go back to formulas back to formula auditing I'll give that trace precedence button to click.
Now in this case it's drawn an arrow and it's a thick arrow all the way through those one two three
four five cells.
The individual totals that make up this 176 thousand dollar limit here.
So a simple button pressed.
Not much more than that you click into a cell or grab this number three down here.
Go back to formulas trace precedence in out drawing.
Right.
Tell me which cells rely on that or feed information into that formula.
So check this out.
Open up the example file or open up one of your own workbooks click into a cell that contains the formula
and trace the precedence